mssqlshrinklogfile

Right-click the database and select Tasks -> Shrink -> Files. Change the type to Log . Under Shrink action, select Release unused space and click OK.

This article describes how to shrink a data or log file in SQL Server by using SQL Server Management Studio or Transact-SQL.

您可以使用 DBCC SHRINKFILE <target_size> 縮減空白檔案的預設大小。 例如，如果建立5 MB 的檔案，然後再將檔案縮減為3 MB 且檔案仍維持空白，則預設的檔案 ...

Shrink Log file 縮小交易紀錄檔​ 多數時候資料庫管理者以及系統管理者，真正想要解決的是縮小交易紀錄檔，也就是令交易紀錄檔在檔案系統中所佔用的大小減少 ...

You can temporarily set recovery model to simple and truncate log. You also need to find the long running transaction that is active and find the root cause.

Right-click the database with Transaction Log that must shrink. Select Tasks > Shrink > Files. Click to shrink files. The interface that comes up gives options ...

MS SQL Server Database Log files can grow large causing your database to go offline and be unavailable if the Transaction Log drive location ...

On the Shrink File window, change the File Type to Log. You can also choose to either release unused space, reorganize pages before releasing ...

Database > Tasks > Shrink > Log files (I usually only show about 250MB of available shrink space anyway). Set database recovery type from Full ...

Expand Databases and then right-click the database that you want to shrink. Point to Tasks, point to Shrink and then click Files. Select the ...